﻿CREATE TABLE [dbo].[TabExtMailList] (
    [MailID]      nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
    [Username]    nvarchar(20)  COLLATE Chinese_PRC_CI_AS NULL,
    [Email]       nvarchar(128) COLLATE Chinese_PRC_CI_AS NULL,
    [ReadFlag]    bit           NULL,
    [FolderID]    int           NULL,
    [HeadersText] nvarchar(max)  COLLATE Chinese_PRC_CI_AS NULL,
    [Subject]     nvarchar(200)  COLLATE Chinese_PRC_CI_AS NULL,
    [TextContent] nvarchar(max)  COLLATE Chinese_PRC_CI_AS NULL,
    [HtmlContent] nvarchar(max)  COLLATE Chinese_PRC_CI_AS NULL,
    [FromName]    nvarchar(50)   COLLATE Chinese_PRC_CI_AS NULL,
    [FromEmail]   nvarchar(128)  COLLATE Chinese_PRC_CI_AS NULL,
    [CcTo]        nvarchar(200)  COLLATE Chinese_PRC_CI_AS NULL,
    [BccTo]       nvarchar(200)  COLLATE Chinese_PRC_CI_AS NULL,
    [Replyto]     nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
    [SendDate]    datetime      NULL,
    [BodySize]    nvarchar(50)   COLLATE Chinese_PRC_CI_AS NULL,
    [Size]        int           NULL
);
GO
